We provide IT Staff Augmentation Services!

Technical Lead Resume

EXPERIENCE SUMMARY:

  • I have total of 11 years 10 months of experience in Information Technology. Involved in various stages of software development lifecycle like requirement analysis, system analysis and design, code development, testing, application support and maintenance during my career.
  • My current domain experience is in Banking and Financial Services as Technical Lead with Confidential at Phoenix, AZ.
  • I also have 6 years of domain experience in Life Science and Healthcare Services as a programmer in development projects on Confidential including MSBI, ASP.NET, C#.NET along with SQL Server and Oracle 8i/9i database knowledge.
  • I have 3 years of project experience in big data technologies.
  • I have successfully cleared the Developer for Apache Hadoop Certification ( CCD - 410 ) provided by Cloudera.

TECHNICAL SKILLS:

Languages: Unix, C#.NET, ASP.NET 2.0, SQL, HTML, CSS, AJAX, JavaScript, Python

Big Data NoSQL Languages: Scala, Hive Query Language ( HiveQL), MongoDB, Pig Latin, Sqoop

Database: SQL Server 2014, Oracle 8i/9i

Operating Systems: Windows 8, Windows XP, Windows 98, Windows 2000, Linux

Tools: / Utilities: Hue, AtScale, IntelliJ, sbt, MobaXTerm, Event Engine, Putty, WinSCP, SSH Secure Shell, HiveConnector, Visual Studio 2013, Visual SourceSafe, PL SQL Developer, SQLPlus, Team Foundation Server, Mercury Quality Center, SQL Server Management Studio, Business Intelligence Development Studio (BIDS), MySQL Workbench

Microsoft BI Suite: Datawarehousing through SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).

CAREER PROFILE:

Confidential

Technical Lead

Tools: Hue, WinSCP, UNIX, HiveQL, AtScale, Impala, IntelliJ, sbt

Responsibilities:

  • Ingest raw data from FTP into the Ingress Layer of TBDP using Data Ingestion Framework.
  • Apply the complex business rules in Spark / Scala to create transformed tables and Facts using RDDs and DataFrames.
  • Use AtScale to design the cube for supporting the dashboards and Tableau Reports.

Confidential, Phoenix, AZ

Tools: Putty, Hive 0.13.0, Hive Connector, WinSCP, UNIX, HiveQL, Sqoop, IntelliJ, sbt

Developer and Technical Lead

Responsibilities:

  • Create scripts in HiveQL to design the external Hive tables corresponding to the input feeds and register the metadata with Cornerstone using Fasttrack.
  • Run scripts in HDFS to analyze the quality of ingested data against the source raw feed.
  • Run map reduce tasks on the data ingested into Hadoop Gold using HiveQL.
  • POC on ingesting feed from SQL server to HDFS using Sqoop.

Confidential, Los Angeles, CA

Technologies Used: Hadoop 2.0, MapReduce, HDFS, Hive 0.9, Pig 0.10, Sqoop 1.4, CA Automation Scheduler

Developer

Responsibilities:

  • Developed and supported Map Reduce Programs running on the cluster.
  • Developed UDFs in PIG for data analysis.
  • Created Hive tables using HiveQL, written UDFs for various datawarehousing and reporting needs on the underlying data.
  • Responsible for identifying requirement specifications gap, communicate with client and their upstream partners on adhoc basis
  • Troubleshoot issues with the quality of ingested data into HDFS and in the Hive datawarehousing layer.

Confidential, Redmond, WA

Technologies Used: Microsoft SQL Server 2014, Reporting Services 2014, Integration Services 2014, Analysis Services 2014.

Technical and Business Analyst

Responsibilities:

  • Thorough impact analysis of source changes, impacted objects including tables, views, procedures, packages, cubes and downstream reports.
  • Timely implementation of changes, end-to-end ETL run, reports validation against production data against the migrated Changepoint data in DAX.
  • Complex scenario creation in DAX-ODS environment, comparison of reports against test source data to ensure ETL scalability for newdata created in DAX-ODS.
  • ETL design for downstream unification of Australia business data ( from DAX ) and rest-of-world data from Changepoint / Productiontill Changepoint is decommissioned and world-wide data isonboarded in DAX.
  • Daily triage with source-system and Unity stakeholders to address and mitigate challenges that surfaced.

Confidential, Bellevue, WA

Technologies Used: Microsoft SQL Server 2012, Reporting Services 2012, Integration Services 2012, Analysis Services 2012.

Technical and Business Analyst

Responsibilities:

  • End-to-End ETL solution design using Metadata Framework, including validations of various sources and scalability analysis to add / remove sources.
  • Analysis & Development for incorporating dimensions sourced from multiple sources and with varying structure/hierarchies.
  • Dimension, Fact, Abstraction View design & development and performance tuning (SSIS, SQL, Cube, Reports)
  • Development and support of SSIS packages, deployed as SQL Server scheduled jobs implemented towards FDM Datawarehousing
  • Ownership of monthly SLA-driven close-week cycle execution to ensure concurrent ETL from multiple sources, RCA and issue resolution so that downstream reports are generated accuratelyon-time.

Confidential

Technologies Used: C#.NET, ASP.NET 2.0, SQL Server 2008, Reporting Services, Integration Services, Analysis Services

Support Analyst

Responsibilities:

  • Development and support of SSIS packages, deployed as SQL Server scheduled jobs implemented towards Datawarehousing
  • Developing, testing and deploying SSRS reports and dashboards including parameterized drilldowns, drillthroughs,charts, lists, table and matrix reports ( tablix in SSRS 2008 ),with standard and data driven subscriptions as per customerrequirements with SQL Server ( SQL/Stored Procedure )and SQL Server Analysis Services ( MDX ) as DataSource.
  • End-to-end production support to entire CCMS datawarehousing and maintenance of the report hosting web applicationInfoAnywhere.
  • Technical lead and point of contact for offshore team to provide solutions to complex technical issues and business intelligencechallenges of other modules.

Confidential

Technologies Used: C#.NET, ASP.NET 2.0, SQL Server 2005, Reporting Services, Integration and Analysis Services.

Support Analyst and Module Lead

Responsibilities:

  • Development and support of SSIS packages, deployed as SQL Server scheduled jobs implemented towards Datawarehousing
  • Developing, testing and deploying SSRS reports and dashboards including drilldowns, drillthroughs, table and matrix reports, with standard or data driven subscriptions as per customer requirements
  • Developing, testing and deploying SSAS cubes
  • Coordinating with different cross-functional groups in case of job failure, data issues or any other issues
  • Support to CTS Reports in InfoAnywhere and cubes which includes CTS Dashboards and monthly dataload of CTS DistrictDashboard.

Confidential

Technologies Used: SQL Server 2005, Reporting Services, Integration Services

Support Analyst

Responsibilities:

  • Day to day monitoring and maintenance support
  • Coordinating enhancements, changes and fixes with Business users
  • Ensuring interface applications are working and all jobs are executing as per schedule
  • Investigation of any data issues in SSRS reports, generating adhoc reports as per user requirements
  • Creating SSIS packages that facilitate the transformation and migration of raw data to SFA On Demand

Confidential

Technologies Used: SQL Server 2005, C#.NET, ASP.NET 2.0

Developer

Responsibilities:

  • System and Requirement analysis of the application
  • Design of the code structure.
  • Development reusable components in .NET.
  • Building application specific test cases.
  • Conducting performance tests on the developed application to optimize performance.
  • Creating defect logs while testing the application.
  • Understanding the overall business knowledge and implementing them in the application.
  • Providing support of the application.

Confidential

Tools: Visual Studio 2005, C#.NET, ASP.NET, Oracle, VSS, MS Visio, Mercury Quality Center, Team Foundation Server.

Developer

Responsibilities:

  • System and Requirement analysis of the application.
  • Design of the code structure.
  • Development reusable components in .NET.
  • Building application specific test cases.
  • Conducting performance tests on the developed application to optimize performance.
  • Creating defect logs while testing the application.
  • Understanding the overall business knowledge and implementing them in the application.
  • Providing support of the application.

Confidential

Tools: Visual Studio 2005, Oracle, VSS, MS Visio, Mercury Quality Center, Team Foundation Server, Virtual Machine Player.

Developer

Responsibilities:

  • System and Requirement analysis of the application to be developed.
  • Design of the code structure.
  • Development reusable components in .NET.
  • Building application specific test cases.
  • Conducting performance tests on the developed application to optimize performance.
  • Creating defect logs while testing the application.
  • Understanding the overall business knowledge and implementing them in the application.
  • Enhancing the system using G2 Infrastructure - It is an Infrastructure code used to develop the system
  • Responsible for the coding of an entire stand-alone application Forms Utility through which Internal Users upload/modify documents available to their customers.

Hire Now